﻿CREATE TABLE [dbo].[sys_LoginUsers]
(
	[UserID] INT NOT NULL PRIMARY KEY IDENTITY , 
    [UserName] NVARCHAR(20) NOT NULL, 
    [Password] VARCHAR(50) NOT NULL, 
    [LastLoginDt] DATETIME NULL, 
    [LastLoginIP] BIGINT NULL, 
    [GUID] VARCHAR(50) NOT NULL, 
    [IsStop] BIT NOT NULL DEFAULT 0, 
    [IsDeleted] BIT NOT NULL DEFAULT 0
)

GO


CREATE UNIQUE INDEX [IX_sys_Users_UserName] ON [dbo].[sys_LoginUsers] ([UserName])
